/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : localhost:3306
 Source Schema         : fyt_soa

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 13/05/2020 17:01:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_admin
-- ----------------------------
DROP TABLE IF EXISTS `sys_admin`;
CREATE TABLE `sys_admin` (
  `Id` varchar(25) NOT NULL COMMENT '唯一编号',
  `RoleId` varchar(100) NOT NULL COMMENT '所属角色',
  `PostId` varchar(100) NOT NULL COMMENT '所属岗位',
  `OrganizeId` varchar(25) NOT NULL COMMENT '所属部门',
  `OrganizeGroupId` varchar(200) DEFAULT NULL COMMENT '所属上级部门组',
  `LoginAccount` varchar(30) NOT NULL COMMENT '登录账号',
  `LoginPassWord` varchar(200) NOT NULL COMMENT '登录密码',
  `HeadPic` varchar(255) DEFAULT NULL COMMENT '头像',
  `FullName` varchar(20) NOT NULL COMMENT '姓名',
  `Mobile` varchar(50) DEFAULT NULL COMMENT '手机号码',
  `Email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `Sex` varchar(10) DEFAULT NULL COMMENT '性别',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `Summary` varchar(200) DEFAULT NULL COMMENT '备注',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  `LoginTime` datetime DEFAULT NULL COMMENT '登录时间',
  `UpLoginTime` datetime DEFAULT NULL COMMENT '上次登录时间',
  `LoginCount` int(11) NOT NULL DEFAULT '0' COMMENT '登录次数',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_admin
-- ----------------------------
BEGIN;
INSERT INTO `sys_admin` VALUES ('1260380358965334016', '1251126367240720384', '1251019168074043392', '1248158071138684928', '1247889786656657408,1248157435479330816,1248158071138684928', 'admins', '1234567', NULL, '李四', '13511111111', '222@qq.com', '男', b'1', b'0', '111111111', '2020-05-13 09:24:29', 'admin', NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_admin` VALUES ('1260394904224403456', '1251126367240720384', '1250983438480183296,1251019168074043392', '1247889786656657408', '1247889786656657408', 'adminsss', '123456', NULL, 'wangwu', '2132131313', NULL, '男', b'1', b'1', NULL, '2020-05-13 10:22:17', 'admin', NULL, NULL, NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_authority
-- ----------------------------
DROP TABLE IF EXISTS `sys_authority`;
CREATE TABLE `sys_authority` (
  `RoleId` varchar(25) NOT NULL COMMENT '角色编号',
  `AdminId` varchar(25) DEFAULT NULL COMMENT '管理员编号',
  `MenuId` varchar(25) DEFAULT NULL COMMENT '菜单编号',
  `BtnFun` varchar(500) DEFAULT NULL COMMENT '按钮功能组',
  `Types` int(11) NOT NULL DEFAULT '1' COMMENT '授权类型1=角色-菜单 2=用户-角色 3=角色-菜单-按钮功能'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for sys_code
-- ----------------------------
DROP TABLE IF EXISTS `sys_code`;
CREATE TABLE `sys_code` (
  `Id` varchar(25) NOT NULL COMMENT '唯一编号',
  `TypeId` varchar(25) NOT NULL COMMENT '分类编号',
  `Name` varchar(50) NOT NULL COMMENT '字典值名称',
  `CodeValues` varchar(50) DEFAULT NULL COMMENT '字典值阈值',
  `Sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `Summary` varchar(100) DEFAULT NULL COMMENT '备注',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='字典信息表';

-- ----------------------------
-- Records of sys_code
-- ----------------------------
BEGIN;
INSERT INTO `sys_code` VALUES ('1258662420646334464', '1258640122090491904', '阿迪', 'A', 1, b'1', b'0', NULL, '2020-05-08 15:38:01', 'admin', NULL, NULL);
INSERT INTO `sys_code` VALUES ('1258672116346261504', '1258647106323877888', '春季', 'A', 91, b'1', b'0', NULL, '2020-05-08 16:16:32', 'admin', NULL, NULL);
INSERT INTO `sys_code` VALUES ('1258672157739847680', '1258647106323877888', '夏季', 'B', 88, b'1', b'0', NULL, '2020-05-08 16:16:42', 'admin', NULL, NULL);
INSERT INTO `sys_code` VALUES ('1258672191487217664', '1258647106323877888', '秋季', 'C', 82, b'1', b'0', NULL, '2020-05-08 16:16:50', 'admin', NULL, NULL);
INSERT INTO `sys_code` VALUES ('1258672223972102144', '1258647106323877888', '冬季', 'D', 1, b'1', b'0', NULL, '2020-05-08 16:16:58', 'admin', NULL, NULL);
INSERT INTO `sys_code` VALUES ('1258675680309284864', '1258647245457330176', '添加', 'Add', 1, b'1', b'0', NULL, '2020-05-08 16:30:42', 'admin', NULL, NULL);
INSERT INTO `sys_code` VALUES ('1258675708239155200', '1258647245457330176', '修改', 'Modify', 1, b'1', b'0', NULL, '2020-05-08 16:30:49', 'admin', NULL, NULL);
INSERT INTO `sys_code` VALUES ('1258676199962578944', '1258647245457330176', '删除', 'Delete', 1, b'1', b'0', NULL, '2020-05-08 16:32:46', 'admin', NULL, NULL);
INSERT INTO `sys_code` VALUES ('1258676306619535360', '1258647245457330176', '审核', 'Audit', 1, b'1', b'0', NULL, '2020-05-08 16:33:11', 'admin', NULL, NULL);
INSERT INTO `sys_code` VALUES ('1258676341004439552', '1258647245457330176', '导入', 'Import', 1, b'1', b'0', NULL, '2020-05-08 16:33:19', 'admin', NULL, NULL);
INSERT INTO `sys_code` VALUES ('1258676436013813760', '1258647245457330176', '导出', 'Export', 1, b'1', b'0', NULL, '2020-05-08 16:33:42', 'admin', NULL, NULL);
INSERT INTO `sys_code` VALUES ('1260488544808472576', '1258647245457330176', '111', '222', 1, b'1', b'1', NULL, '2020-05-13 16:34:22', 'admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_codetype
-- ----------------------------
DROP TABLE IF EXISTS `sys_codetype`;
CREATE TABLE `sys_codetype` (
  `Id` varchar(25) NOT NULL COMMENT '唯一编号',
  `ParentId` varchar(32) NOT NULL COMMENT '父节点',
  `Layer` int(11) NOT NULL DEFAULT '1' COMMENT '层级',
  `Name` varchar(30) DEFAULT NULL COMMENT '分类名称',
  `Sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
  `IsSystem` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否系统内置集成',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='字典分类信息';

-- ----------------------------
-- Records of sys_codetype
-- ----------------------------
BEGIN;
INSERT INTO `sys_codetype` VALUES ('1258634388292374528', '0', 1, '商品规格', 1, b'0', b'0', '2020-05-08 13:46:37', 'admin', NULL, NULL);
INSERT INTO `sys_codetype` VALUES ('1258640122090491904', '1258634388292374528', 2, '品牌', 1, b'0', b'0', '2020-05-08 14:09:24', 'admin', NULL, NULL);
INSERT INTO `sys_codetype` VALUES ('1258647106323877888', '1258634388292374528', 2, '季节', 1, b'0', b'0', '2020-05-08 14:37:09', 'admin', NULL, NULL);
INSERT INTO `sys_codetype` VALUES ('1258647173655040000', '0', 1, '系统权限', 1, b'1', b'0', '2020-05-08 14:37:25', 'admin', NULL, NULL);
INSERT INTO `sys_codetype` VALUES ('1258647245457330176', '1258647173655040000', 2, '按钮功能', 1, b'1', b'0', '2020-05-08 14:37:43', 'admin', NULL, NULL);
INSERT INTO `sys_codetype` VALUES ('1258652724044632064', '1258634388292374528', 2, '1111', 1, b'0', b'1', '2020-05-08 14:59:29', 'admin', NULL, NULL);
INSERT INTO `sys_codetype` VALUES ('1258675395226636288', '0', 1, '测试', 1, b'0', b'1', '2020-05-08 16:29:34', 'admin', NULL, NULL);
INSERT INTO `sys_codetype` VALUES ('1258675415686451200', '1258675395226636288', 2, 'aaa', 1, b'0', b'1', '2020-05-08 16:29:39', 'admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `Id` varchar(25) NOT NULL,
  `LogType` int(11) NOT NULL COMMENT '日志类型  0=登录  1=操作',
  `Module` varchar(30) DEFAULT NULL COMMENT '操作模块',
  `OperateType` varchar(20) DEFAULT NULL COMMENT '操作类型:例如添加、修改',
  `Method` varchar(10) DEFAULT NULL COMMENT '提交类型：get/post/delete',
  `OperateUser` varchar(30) DEFAULT NULL COMMENT '操作人',
  `IP` varchar(20) DEFAULT NULL COMMENT 'IP',
  `Address` varchar(50) DEFAULT NULL COMMENT '操作地址',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '操作状态',
  `Message` varchar(2000) DEFAULT NULL COMMENT '详细信息',
  `OperateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间',
  `Browser` varchar(200) DEFAULT NULL COMMENT '浏览器信息',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='登录日志\r\n操作日志\r\n任务日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES ('1260490821619290112', 1, 'WeatherForecast', '添加', 'Get', 'admins', '::1', '/WeatherForecast', b'1', '\n 方法：Get \n Url地址：/WeatherForecast \n 请求方式：GET \n 参数：{}\n 耗时：0.9998 毫秒', '2020-05-13 16:43:25', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36');
INSERT INTO `sys_log` VALUES ('1260490917496885248', 1, 'SysMenu', '查询', 'List', 'admins', '::1', '/SysMenu?page=1', b'1', '\n 方法：List \n Url地址：/SysMenu?page=1 \n 请求方式：GET \n 参数：{\"param\":{\"page\":1,\"limit\":15,\"id\":null,\"key\":null,\"status\":0}}\n 耗时：263.739 毫秒', '2020-05-13 16:43:48', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36');
INSERT INTO `sys_log` VALUES ('1260491963073957888', 1, 'SysMenu', '查询', 'List', 'admins', '::1', '/SysMenu?page=1', b'1', '\n 方法：List \n Url地址：/SysMenu?page=1 \n 请求方式：GET \n 参数：{\"param\":{\"page\":1,\"limit\":15,\"id\":null,\"key\":null,\"status\":0}}\n 耗时：43.6819 毫秒', '2020-05-13 16:47:57', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `Id` varchar(25) NOT NULL COMMENT '唯一编号',
  `Name` varchar(30) NOT NULL COMMENT '菜单名称',
  `ParentId` varchar(25) DEFAULT NULL COMMENT '父节点',
  `ParentGroupId` varchar(100) DEFAULT NULL COMMENT '父节点集合组',
  `Code` varchar(30) DEFAULT NULL COMMENT '权限标识',
  `Layer` int(11) NOT NULL DEFAULT '0' COMMENT '菜单层级',
  `Urls` varchar(100) DEFAULT NULL COMMENT '路由地址',
  `Icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `Sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `Types` int(11) NOT NULL DEFAULT '1' COMMENT '菜单类型：1=目录  2=菜单',
  `BtnFun` varchar(1000) DEFAULT NULL COMMENT '菜单按钮',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES ('1258686437235232768', '系统管理', '0', NULL, 'Sys', 1, NULL, 'el-icon-orange', 1, b'1', b'0', 1, 'null', '2020-05-08 17:13:27', 'admin', NULL, NULL);
INSERT INTO `sys_menu` VALUES ('1258687635354947584', '部门管理', '1258686437235232768', '1258686437235232768,1258687635354947584', 'SysOrganize', 2, 'sys/organize', NULL, 4, b'1', b'0', 2, 'null', '2020-05-08 17:18:12', 'admin', NULL, NULL);
INSERT INTO `sys_menu` VALUES ('1260452590072762368', '角色管理', '1258686437235232768', '1258686437235232768,1260452590072762368', 'SysRole', 2, '/sys/role', NULL, 5, b'1', b'0', 2, '[{\"id\":\"1258675680309284864\",\"name\":\"添加\",\"value\":\"Add\"},{\"id\":\"1258675708239155200\",\"name\":\"修改\",\"value\":\"Modify\"},{\"id\":\"1258676199962578944\",\"name\":\"删除\",\"value\":\"Delete\"}]', '2020-05-13 14:11:30', 'admin', NULL, NULL);
INSERT INTO `sys_menu` VALUES ('1260452731953483776', '岗位管理', '1258686437235232768', '1258686437235232768,1260452731953483776', 'SysPost', 2, '/sys/post', NULL, 6, b'1', b'0', 2, '[{\"id\":\"1258675680309284864\",\"name\":\"添加\",\"value\":\"Add\"},{\"id\":\"1258675708239155200\",\"name\":\"修改\",\"value\":\"Modify\"},{\"id\":\"1258676199962578944\",\"name\":\"删除\",\"value\":\"Delete\"}]', '2020-05-13 14:12:04', 'admin', NULL, NULL);
INSERT INTO `sys_menu` VALUES ('1260452840476905472', '用户管理', '1258686437235232768', '1258686437235232768,1260452840476905472', 'SysUser', 2, '/sys/user', NULL, 7, b'1', b'0', 2, '[{\"id\":\"1258675680309284864\",\"name\":\"添加\",\"value\":\"Add\"},{\"id\":\"1258675708239155200\",\"name\":\"修改\",\"value\":\"Modify\"},{\"id\":\"1258676199962578944\",\"name\":\"删除\",\"value\":\"Delete\"}]', '2020-05-13 14:12:30', 'admin', NULL, NULL);
INSERT INTO `sys_menu` VALUES ('1260452945938485248', '菜单管理', '1258686437235232768', '1258686437235232768,1260452945938485248', 'SysMenu', 2, '/sys/menu', NULL, 8, b'1', b'0', 2, '[{\"id\":\"1258675680309284864\",\"name\":\"添加\",\"value\":\"Add\"},{\"id\":\"1258675708239155200\",\"name\":\"修改\",\"value\":\"Modify\"},{\"id\":\"1258676199962578944\",\"name\":\"删除\",\"value\":\"Delete\"},{\"id\":\"1258676306619535360\",\"name\":\"审核\",\"value\":\"Audit\"}]', '2020-05-13 14:12:55', 'admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_organize
-- ----------------------------
DROP TABLE IF EXISTS `sys_organize`;
CREATE TABLE `sys_organize` (
  `Id` varchar(25) NOT NULL COMMENT '唯一编号',
  `ParentId` varchar(25) NOT NULL COMMENT '父节点',
  `Name` varchar(30) NOT NULL COMMENT '部门名称',
  `ParentIdList` varchar(500) DEFAULT NULL COMMENT '父节点集合',
  `Layer` int(11) NOT NULL DEFAULT '0' COMMENT '部门层级',
  `Sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '删除状态',
  `LeaderUser` varchar(20) DEFAULT NULL COMMENT '部门负责人',
  `LeaderMobile` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `LeaderEmail` varchar(50) DEFAULT NULL COMMENT '联系邮箱',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) NOT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_organize
-- ----------------------------
BEGIN;
INSERT INTO `sys_organize` VALUES ('1247889786656657408', '0', 'Fyt集团', '1247889786656657408', 1, 28, b'1', b'0', '1', '111', '1111', '2020-04-08 22:11:24', 'admin', NULL, NULL);
INSERT INTO `sys_organize` VALUES ('1248157435479330816', '1247889786656657408', '行政/人事', '1247889786656657408,1248157435479330816', 2, 1, b'1', b'0', '李四', '13688888888', '58555@qq.com', '2020-04-09 15:54:57', 'admin', NULL, NULL);
INSERT INTO `sys_organize` VALUES ('1248158071138684928', '1248157435479330816', '人事部', '1247889786656657408,1248157435479330816,1248158071138684928', 3, 1, b'1', b'0', '李总', '16544444444', '55545444@qq.com', '2020-04-09 15:57:28', 'admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post` (
  `Id` varchar(25) NOT NULL COMMENT '唯一编号',
  `Name` varchar(30) NOT NULL COMMENT '岗位名称',
  `Number` varchar(6) DEFAULT NULL COMMENT '岗位编码',
  `Sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '岗位状态',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '删除状态',
  `Summary` varchar(500) DEFAULT NULL COMMENT '备注信息',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) NOT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_post` VALUES ('1250983438480183296', '产品经理', '100000', 1, b'1', b'0', '产品经理', '2020-04-17 11:04:29', 'admin', NULL, NULL);
INSERT INTO `sys_post` VALUES ('1251019168074043392', '项目经理', '100001', 1, b'1', b'0', '项目经理', '2020-04-17 13:26:27', 'admin', NULL, NULL);
INSERT INTO `sys_post` VALUES ('1251019232876040192', '测试经理', '100002', 1, b'1', b'0', '测试经理', '2020-04-17 13:26:27', 'admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `Id` varchar(25) NOT NULL COMMENT '唯一编号',
  `Name` varchar(30) NOT NULL COMMENT '角色名称',
  `ParentId` varchar(25) DEFAULT NULL COMMENT '角色父节点',
  `Layer` int(11) NOT NULL DEFAULT '1' COMMENT '角色层级',
  `Number` varchar(6) DEFAULT NULL COMMENT '角色编号',
  `IsSystem` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否超级管理员',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `Sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
  `Summary` varchar(500) DEFAULT NULL COMMENT '描述',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` char(10) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1251076856711614464', '默认', '0', 1, NULL, b'0', b'1', 1, NULL, b'0', '2020-04-17 17:15:41', 'admin', NULL, NULL);
INSERT INTO `sys_role` VALUES ('1251122647241199616', '超级管理员', '1251076856711614464', 1, NULL, b'1', b'1', 1, NULL, b'0', '2020-04-17 20:17:38', 'admin', NULL, NULL);
INSERT INTO `sys_role` VALUES ('1251126367240720384', '子管理员', '1251076856711614464', 1, NULL, b'0', b'1', 1, NULL, b'0', '2020-04-17 20:32:25', 'admin', NULL, NULL);
INSERT INTO `sys_role` VALUES ('1251126415047397376', '职务', '0', 1, NULL, b'0', b'1', 1, NULL, b'0', '2020-04-17 20:32:37', 'admin', NULL, NULL);
INSERT INTO `sys_role` VALUES ('1251126767943553024', '财务管理员', '1251126415047397376', 1, NULL, b'0', b'1', 1, NULL, b'0', '2020-04-17 20:34:01', 'admin', NULL, NULL);
INSERT INTO `sys_role` VALUES ('1251126879725948928', '人事管理员', '1251126415047397376', 1, NULL, b'0', b'1', 1, NULL, b'0', '2020-04-17 20:34:28', 'admin', NULL, NULL);
INSERT INTO `sys_role` VALUES ('1259052073308262400', '7777', '1251076856711614464', 1, NULL, b'0', b'1', 1, NULL, b'0', '2020-05-09 17:26:21', 'admin', NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
